2015-05-01 - 9203.1000 - Spec - Create Material Grid Master Data #MasterData
SPECIFICATIONS
9203.1000 - Create Material/Grid Master Data
Purpose
Need to create Material/Grid level master data object according to specification and also add CPU(Cost per unit) to 0MAT_PLANT and CPU/MRP to 0MAT_SALES.
Admin Info
Purpose
|
Need to create Material/Grid Master Data, add Cost to 0MAT_PLANT and add CPU/MRP to 0MAT_SALES.
|
Requested By
|
Bill Adams
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
05/27/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZMAT_GRID, 0MAT_PLANT, 0MAT_SALES
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
70
|
4
|
Unit test in DEV
|
12
|
5
|
Unit test in QUA
|
10
|
6
|
Transports
|
02
|
|
TOTAL
|
102
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email From Greg on 05-20-2015:
Grid Material Master:
PeopleSoft ID is located in table ZNE_MATL_CONV which is a size/material join. Also, I know table MEAN’s key is UPC, but I’d like to flip it the other way. I want the Info Object to be Material and compounded with grid value. That way UPC will be an attribute.
Cost:
Standard price(cost) will have to be added to the 0PLANT_MAT because it’s maintained at the plant/material level. Seems easy enough to just enhance 0MAT_PLANT_ATTR with the standard price. It’s located at MBEW-STPRS and the table is an easy plant/material join.
In Scope:
Need to create new generic extractors for Material Grid extractor and to enhance the Cost field to 0MAT_PLANT extractor.
Out of Scope:
The logic given to update MSRP & List PRICE is at Material & Sales org level, but in the 0MAT_SALES extractor the key fields are Material, Sales org & Distribution channel. This would update wrong results when distribution value is not considered.
Solution Summary
Grid Material Master:
1. Need to create Generic datasources based on MEAN & ZNE_MATL_CONV tables.
2. Need to add required characteristics to the Material Grid master data object.
3. Need to map the datasources to the Master data object.
4. Need to test the data in BPD.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the data is populated correctly & also validated with MEAN table in NEP.
|
Data should be populated correctly & should be validated with NEP tables.
|
2
|
Check if the all the objects are collected into the transport request.
|
All the newly created objects must be collected into the transport request.
|
Cost to 0MAT_PLANT:
1. Need to enhance the material plant extractor with Standard price & Currency.
2. Need to write the logic in customer exit to populate Standard price & Currency.
3. Need to add cost & currency to material plant info object & map them with standard price & currency.
4. Need to validate the data in BPD.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the data for cost & currency are populated correctly as per the logic written.
|
Data for cost & currency should be populated correctly as per the logic written.
|
2
|
Check if the logic in customer exit is optimized & unwanted code is removed.
|
Logic should be optimized & also unwanted code needs to be removed.
|
3
|
Check if comments are updated for the logic written.
|
Comments should be updated for the logic that has been written.
|
4
|
Check if the all the objects are collected into the transport request.
|
All the newly created objects must be collected into the transport request.
|
Solution Details
Grid Material Master:
1. Need to create Generic datasources ZDS_MEAN and ZDS_PS_MID based on MEAN & ZNE_MATL_CONV tables.
2. Need to add required characteristics to the Material Grid master data object (ZMAT_GRID).
3. Need to map the datasources ZDS_MEAN and ZDS_PS_MID to the Master data object ZMAT_GRID.
4. Need to test the data in BPD & BPQ.
Cost to 0MAT_PLANT:
1. Need to enhance the material plant extractor 0MAT_PLANT_ATTR with Standard price ZZSTPRS & Currency ZZWAERS.
2. Need to write the logic in customer exit to populate Standard price ZZSTPRS & Currency ZZWAERS.
3. Need to add cost ZRP_COST & currency 0CURRENCY to material plant info object 0MAT_PLANT & map them with standard price ZZSTPRS & Currency ZZWAERS.
4. Need to validate the data in BPD & BPQ.
Issues
The logic given to update MSRP & List PRICE is at Material & sales org level, but in the 0MAT_SALES extractor the key fields are Material, Sales org & Distribution channel. This would update wrong results when distribution channel is not considered.